package com.itheima.mapper;


import com.itheima.pojo.OrderSetting;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import javax.xml.crypto.Data;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;

@Mapper
public interface OrderSettingDao {


   List<OrderSetting>getOrderSettingByMonth(LocalDate begin,LocalDate end);

   // 根据日期修改预约人数
   @Update("update chuanzhi.t_ordersetting set number=#{number} where orderDate=date (#{orderDate})")
   void editNumberByOrderDate(OrderSetting orderSetting);

   //根据excel更新预约人数
   @Update("update chuanzhi.t_ordersetting set number=#{number} where orderDate=#{orderDate}")
   void updateBaseOnExcel(Date orderDate, int number);
}
